Who is familiar with MySQL? Help me!# Biology - 生物学
m*g
1 楼
在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
有类似经验的人说说吧，非常感谢。
站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
有类似经验的人说说吧，非常感谢。
A*8
2 楼
韩国最近的娱乐圈特别热闹，从金贤重到现在的朴有天，闹的满城风雨，可想而知这两
个人的演艺生涯估计也就到头了。
夜店F4就有金贤重、朴有天、金在中、TOP，已经有两个人出事儿了，要是这另外的两
个人出事估计就不是几个人的事情了吧，怎么也得有好多人。现在TOP那么红也快去当
兵了，赶脚够呛呀。
艺人的私生活太乱，真是不知道什么时候就背后来一枪，有那句老话叫你约的炮跪着也
要打完，就没有不透风的墙，还是在娱乐圈，这肯定是不注意就要死的。
个人的演艺生涯估计也就到头了。
夜店F4就有金贤重、朴有天、金在中、TOP，已经有两个人出事儿了，要是这另外的两
个人出事估计就不是几个人的事情了吧，怎么也得有好多人。现在TOP那么红也快去当
兵了，赶脚够呛呀。
艺人的私生活太乱，真是不知道什么时候就背后来一枪，有那句老话叫你约的炮跪着也
要打完，就没有不透风的墙，还是在娱乐圈，这肯定是不注意就要死的。
s*2
3 楼
I am using a software which must interact with MySQL database. I have
installed this software (named stacks) and MySQL. There are two command when
I use this software:
~/directory mysql -e "CRAETA DATABASE 1"
~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
I am a very new to linux system and MySQL. I know the first command is going
to create a database in MySQL named 1. The manual of the software explains
the second command as "send the database table definitions to the server to
create all the necessary components of the database ". When I run the first
command under MySQL, it is ok. But it will show "Error 1064: you have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near "1 < /usr/local/share/stacks
/sql/stacks.sql" at line1" when I run the second command.
I am wondering whether someone know what's the actual meaning of the second
command. I am totally confused.
PS: the software I used is "Stacks" and installed in the default path "/usr/
local/share/stacks".
Thanks, everyone! I am in the lab and can't type in Chinese. Sorry.
installed this software (named stacks) and MySQL. There are two command when
I use this software:
~/directory mysql -e "CRAETA DATABASE 1"
~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
I am a very new to linux system and MySQL. I know the first command is going
to create a database in MySQL named 1. The manual of the software explains
the second command as "send the database table definitions to the server to
create all the necessary components of the database ". When I run the first
command under MySQL, it is ok. But it will show "Error 1064: you have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near "1 < /usr/local/share/stacks
/sql/stacks.sql" at line1" when I run the second command.
I am wondering whether someone know what's the actual meaning of the second
command. I am totally confused.
PS: the software I used is "Stacks" and installed in the default path "/usr/
local/share/stacks".
Thanks, everyone! I am in the lab and can't type in Chinese. Sorry.
m*g
4 楼
收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
可是登录网站一看，护照号码还是不对的。
【在 m**********g 的大作中提到】
: 在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
: 站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
: 有类似经验的人说说吧，非常感谢。
可是登录网站一看，护照号码还是不对的。
【在 m**********g 的大作中提到】
: 在ustraveldocs上注册时，护照填错了，以为数字1是字母I，签证费也交了。现在在网
: 站上反馈让他们帮忙修改，但是不知道他们需要多久，也不知道签证费是否需要重交。
: 有类似经验的人说说吧，非常感谢。
P*l
5 楼
打开那个stacks.sql文件看看语法哪错了啊？
m*g
6 楼
再次提供反馈，并附上护照页的扫描版之后，他们更新了护照号码。
反应还是比较快的，赞一个。
不过，我在反馈中询问是否需要重新去中信交费，他们没有回应，我想，应该是不需要
吧。
【在 m**********g 的大作中提到】
: 收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
: 可是登录网站一看，护照号码还是不对的。
反应还是比较快的，赞一个。
不过，我在反馈中询问是否需要重新去中信交费，他们没有回应，我想，应该是不需要
吧。
【在 m**********g 的大作中提到】
: 收到网站回复，“您的申请个案已更新，请重新登录账户查看详情”。
: 可是登录网站一看，护照号码还是不对的。
s*8
7 楼
the 2nd command is about creating tables in your database 1.
if you are not familiar with linux, you can download and install MySQL
Workbench on windows and log to your mysql server on linux. Then execute "
stacks.sql" in MySQL Workbench.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
if you are not familiar with linux, you can download and install MySQL
Workbench on windows and log to your mysql server on linux. Then execute "
stacks.sql" in MySQL Workbench.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
I*y
8 楼
install a MySQL management UI software such as phpmyadmin on your server,
and then import the .sql file through the user interface, and it can track
down what error (if any) it throws to you.
the second command line is an attempt to import the mysql dump file. However, I think the command
line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
ssh), use this command:
mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
this command line assumes that your mysql server is your localhost.
make sure the mysql username above has privilege to write to the database_name, or just use the root user.
When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
save it. If you have opened it and saved it, some lines in the dump file
may have been altered, throwing errors like this Error 1064.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
and then import the .sql file through the user interface, and it can track
down what error (if any) it throws to you.
the second command line is an attempt to import the mysql dump file. However, I think the command
line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
ssh), use this command:
mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
this command line assumes that your mysql server is your localhost.
make sure the mysql username above has privilege to write to the database_name, or just use the root user.
When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
save it. If you have opened it and saved it, some lines in the dump file
may have been altered, throwing errors like this Error 1064.
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
L*d
9 楼
stacks.sql这个文件里的某一个（些）statement有语法错误
打开那个文件看看
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
打开那个文件看看
when
going
explains
to
first
【在 s********2 的大作中提到】
: I am using a software which must interact with MySQL database. I have
: installed this software (named stacks) and MySQL. There are two command when
: I use this software:
: ~/directory mysql -e "CRAETA DATABASE 1"
: ~/directory 1 < /usr/local/share/stacks/sql/stacks.sql
: I am a very new to linux system and MySQL. I know the first command is going
: to create a database in MySQL named 1. The manual of the software explains
: the second command as "send the database table definitions to the server to
: create all the necessary components of the database ". When I run the first
: command under MySQL, it is ok. But it will show "Error 1064: you have an
s*2
10 楼
谢谢提醒，我对这个真是太不熟悉了，结果我打开那个stacks.sql一看，是空白的。呜
呜。我也不知道是不是我安装软件的时候出现问题了。
【在 P**l 的大作中提到】
: 打开那个stacks.sql文件看看语法哪错了啊？
呜。我也不知道是不是我安装软件的时候出现问题了。
【在 P**l 的大作中提到】
: 打开那个stacks.sql文件看看语法哪错了啊？
s*2
11 楼
Thanks, IVYtony! I am using Ubuntu 11.04. I changed the stacks.sql, and
shouldn't have a problem with it any more. But when I run the second command
, the error show up "error 1045 (28000): Access denied for user 'root'@'
localhost' (using password : No)" . I googled the error. Most suggested
resetting the password. But if I run "mysql -u root -p" and enter my
password. I can get into the mysql. I am totally don't know how to do
troubleshooting. I have been working on this for almost one week, starting
installing the linux system, the software, and MySQL. I feel so frustrated.
:( Any other suggestion would be greatly appreciated.
However, I think the command
are on the kernel prompt (e.g.
dumpfile.sql
name, or just use the root user.
don't open it and
【在 I*****y 的大作中提到】
: install a MySQL management UI software such as phpmyadmin on your server,
: and then import the .sql file through the user interface, and it can track
: down what error (if any) it throws to you.
: the second command line is an attempt to import the mysql dump file. However, I think the command
: line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
: ssh), use this command:
: mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
: this command line assumes that your mysql server is your localhost.
: make sure the mysql username above has privilege to write to the database_name, or just use the root user.
: When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
shouldn't have a problem with it any more. But when I run the second command
, the error show up "error 1045 (28000): Access denied for user 'root'@'
localhost' (using password : No)" . I googled the error. Most suggested
resetting the password. But if I run "mysql -u root -p" and enter my
password. I can get into the mysql. I am totally don't know how to do
troubleshooting. I have been working on this for almost one week, starting
installing the linux system, the software, and MySQL. I feel so frustrated.
:( Any other suggestion would be greatly appreciated.
However, I think the command
are on the kernel prompt (e.g.
dumpfile.sql
name, or just use the root user.
don't open it and
【在 I*****y 的大作中提到】
: install a MySQL management UI software such as phpmyadmin on your server,
: and then import the .sql file through the user interface, and it can track
: down what error (if any) it throws to you.
: the second command line is an attempt to import the mysql dump file. However, I think the command
: line is wrong, though I'm not sure what Linux distro you are using. If you are on the kernel prompt (e.g.
: ssh), use this command:
: mysql -u username -p database_name < /path/to/the/mysql/dump/directory/dumpfile.sql
: this command line assumes that your mysql server is your localhost.
: make sure the mysql username above has privilege to write to the database_name, or just use the root user.
: When you import the file, make sure it's an intact mysql dump, meaning you don't open it and
相关阅读
熬夜工作容易得血液病11g拿炸药奖是迟早的事情，为什么这么多人喷他？基础研究就不应该靠人力财力堆砌【供求】波士顿西南一大房带卫生间出租 (转载)Paper help （包子）卢瑟福说过。。。。国际学术界高度关注施一公研究组《科学》论文成果【写作小铺】生物医药文章写作小tipspaper help, thanks!有些人说生物发展技术革新不重要我笑了那个领域想成功不是需要努力的？为啥大家都说CSHL的人很变态？施的工作可能贡献两个诺奖施一公在国内做的风生水起，令我感慨一个老鼠的肿瘤能否在另一只老鼠的皮下生长？热烈祝贺老乡兼校友施一公预备得诺贝尔奖MD anderson和MSKCC那个basic research更牛？为什么施一公总有人批评我预测，11g至少至少可以得五次诺贝尔奖生物科研变成民工搬砖谁功劳最大？