You can use [`SHOW CREATE TABLE`][1] for this.

&gt; Shows the CREATE TABLE statement that
&gt; creates the given table. The statement
&gt; requires the SELECT privilege for the
&gt; table. As of MySQL 5.0.1, this
&gt; statement also works with views.

E.g.:

    SHOW CREATE TABLE MyTablename


  [1]: http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html

I&#39;m not a MySQL expert by any means but the following [site][1] suggests using the `-d` or `--no-data` option of mysqldump:

    mysqldump -d -h localhost -u root -pmypassword databasename &gt; dumpfile.sql

It worked for me.

  [1]: http://www.howtogeek.com/howto/programming/mysql/dump-just-the-table-structure-to-a-file-in-mysql/

if u have &quot;MySQL Workbench&quot; v6.0

1) click on any table of the database.

2) Right-click and select &quot;Tables Maintenance&quot;

3) Under &quot;Tables&quot; tab, highlight the tables u want to export, right-click and select &quot;Send to SQL Editor&quot;&gt;&quot;Create Schema&quot;

It is already answered in the link below:  
https://stackoverflow.com/questions/6175473/mysql-export-schema-without-data

Use the command below to take the structure or schema dump.

    mysqldump -u root -p --no-data dbname &gt; schema.sql

     read -p &quot;Please Enter a Message:&quot; message

How can I add a line break after `Message:`?

How do I add a line break for read command?

I have a logging table that will contain millions of writes for statistical reasons. All the columns are int foreign keys. I am also going to add a timestamp column for each row. Given that DATETIME takes 8bits - I will be using `int(10) unsigned` to cut the storage space (and index on that column) in half. 

However, I&#39;m wondering when this column would no longer work. At 3:14:07AM on 19th January 2038 the value 9,999,999,999 will be a problem for UNIX timestamps - but an unsigned int in MySQL only holds up to 4,294,967,295 and the timestamp 4294967295 is showing an invalid number in my PHP application.

**So what does this mean? Is the end of the storing int timestamps in MySQL going to be sometime in 2021 since it can&#39;t make it all the way to 9999999999?**

**Answer:** 

 1. 2147483647 is 2038 (not 9999999999) so there is no problem. 
 2. `unsigned` isn&#39;t needed since 2147483647 fits fine in a signed MySQL int.

How should unix timestamps be stored in int columns?

I need to export a mysql table, but it has like 5gb of entries, so I only want the structure. I am trying to do it from a simple php doing a sql query, how can I do that?

How to dump mysql table structure without data with a SQL query?

<p>I need to export a mysql table, but it has like 5gb of entries, so I only want the structure. I am trying to do it from a simple php doing a sql query, how can I do that?</p>


I need to list all triggers in SQL Server database with table name and table&#39;s schema.

I&#39;m almost there with this:

    SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj),
      isupdate = OBJECTPROPERTY( id, &#39;ExecIsUpdateTrigger&#39;), isdelete = OBJECTPROPERTY( id, &#39;ExecIsDeleteTrigger&#39;),
      isinsert = OBJECTPROPERTY( id, &#39;ExecIsInsertTrigger&#39;), isafter = OBJECTPROPERTY( id, &#39;ExecIsAfterTrigger&#39;),
      isinsteadof = OBJECTPROPERTY( id, &#39;ExecIsInsteadOfTrigger&#39;),
      [disabled] = OBJECTPROPERTY(id, &#39;ExecIsTriggerDisabled&#39;) 
    FROM sysobjects INNER JOIN sysusers ON sysobjects.uid = sysusers.uid
    WHERE type = &#39;TR&#39;

I just need to get the table&#39;s schema also.

Need to list all triggers in SQL Server database with table name and table&#39;s schema

I have a column in one of my tables which has been assigned an index. It is preventing me from having two of the same ID number. 

I am assuming the reason it is not letting me have two entries of the same ID is because it has been set to be Unique.

I am wondering how do I remove this rule so that I can insert the same ID number several times.

Cheers

phpMyAdmin Removing an index

What happens if a clustered index is not unique? Can it lead to bad performance because inserted rows flow to an &quot;overflow&quot; page of some sorts?

Is it &quot;made&quot; unique and if so how? What is the best way to make it unique?

I am asking because I am currently using a clustered index to divide my table in logical parts, but the performance is so-so, and recently I got [the advice][1] to make my clustered indexes unique. I&#39;d like a second opinion on that.

  [1]: https://stackoverflow.com/questions/3733735/clustered-indexes-on-non-identity-columns-to-speed-up-bulk-inserts/4331661#4331661

Do clustered indexes have to be unique?

I&#39;ve got the following query but it doesn&#39;t seem to work.

    $q = $this-&gt;em-&gt;createQueryBuilder()
        -&gt;update(&#39;models\User&#39;, &#39;u&#39;)
        -&gt;set(&#39;u.username&#39;, $username)
        -&gt;set(&#39;u.email&#39;, $email)
        -&gt;where(&#39;u.id = ?1&#39;)
        -&gt;setParameter(1, $editId)
        -&gt;getQuery();
    $p = $q-&gt;execute();

This returns the following error message:

&gt; Fatal error: Uncaught exception
&gt; &#39;Doctrine\ORM\Query\QueryException&#39;
&gt; with message &#39;[Semantical Error] line
&gt; 0, col 38 near &#39;testusername WHERE&#39;:
&gt; Error: &#39;testusername&#39; is not defined.&#39;
&gt; in ...

I would be glad of any help

Doctrine 2: Update query with query builder

&gt; **Possible Duplicate:**  
&gt; [What is the etymology of &amp;#39;slug&amp;#39;?](https://stackoverflow.com/questions/4230846/what-is-the-etymology-of-slug)  

&lt;!-- End of automatically inserted text --&gt;

In CouchDB definitive guide the author used key &quot;slug&quot; in a document.

    {
       &quot;title&quot;: &quot;Hello World&quot;,
       &quot;slug&quot;: &quot;hello_world&quot;
    }

What does &quot;slug&quot; mean and why is it used?


What does &quot;slug&quot; mean

I am using Fedora 14 and I have MySQL and MySQL server 5.1.42 installed and running.
Now I tried to do this as root user:

    gem install mysql

But I get this error:

    Building native extensions.  This could take a while...
    ERROR:  Error installing mysql:
        ERROR: Failed to build gem native extension.

    /usr/bin/ruby extconf.rb
    mkmf.rb can&#39;t find header files for ruby at /usr/lib/ruby/ruby.h


    Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1 for inspection.
    Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.8.1/ext/mysql_api/gem_make.out

What&#39;s wrong here? In installed ruby 1.8.7. and the latest rubygems 1.3.7.


gem install: Failed to build gem native extension (can&#39;t find header files)

For CakePHP application, I created MySQL database. 

Which tool to be used to create ER Diagram of database? Fields and relations between tables are created in a way cakePHP likes.


thank you in advance!

Generate ER Diagram from existing MySQL database, created for CakePHP

How can I best write a query that selects 10 rows randomly from a total of 600k?

MySQL select 10 random rows from 600K rows fast

We have a database with a table whose values were imported from another system. There is an auto-increment column, and there are no duplicate values, but there are missing values. For example, running this query:

    select count(id) from arrc_vouchers where id between 1 and 100

should return 100, but it returns 87 instead. Is there any query I can run that will return the values of the missing numbers? For example, the records may exist for id 1-70 and 83-100, but there are no records with id&#39;s of 71-82. I want to return 71, 72, 73, etc.

Is this possible?

How to find gaps in sequential numbering in mysql?

I have some difficulties with mySQL commands that I want to do. 

    SELECT a.timestamp, name, count(b.name) 
    FROM time a, id b 
    WHERE a.user = b.user
      AND a.id = b.id
      AND b.name = &#39;John&#39;
      AND a.timestamp BETWEEN &#39;2010-11-16 10:30:00&#39; AND &#39;2010-11-16 11:00:00&#39; 
    GROUP BY a.timestamp

This is my current output statement.


    timestamp            name  count(b.name)
    -------------------  ----  -------------
    2010-11-16 10:32:22  John  2
    2010-11-16 10:35:12  John  7
    2010-11-16 10:36:34  John  1
    2010-11-16 10:37:45  John  2
    2010-11-16 10:48:26  John  8
    2010-11-16 10:55:00  John  9
    2010-11-16 10:58:08  John  2

How do I group them into 5 minutes interval results?

I want my output to be like

    timestamp            name  count(b.name)
    -------------------  ----  -------------
    2010-11-16 10:30:00  John  2
    2010-11-16 10:35:00  John  10
    2010-11-16 10:40:00  John  0
    2010-11-16 10:45:00  John  8
    2010-11-16 10:50:00  John  0
    2010-11-16 10:55:00  John  11 


Content Type	Original Author	Original Content on Stackoverflow
Question	Hurans	View Question on Stackoverflow
Solution 1 - Database	D'Arcy Rittich	View Answer on Stackoverflow
Solution 2 - Database	mp31415	View Answer on Stackoverflow
Solution 3 - Database	gan gary	View Answer on Stackoverflow
Solution 4 - Database	Pramatha V	View Answer on Stackoverflow

How to dump mysql table structure without data with a SQL query?

Database Problem Overview

Database Solutions

Solution 1 - Database

Solution 2 - Database

Solution 3 - Database

Solution 4 - Database

How should unix timestamps be stored in int columns?

How do I add a line break for read command?

Attributions